UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2LqFzHYDxhm6syZNCDqA04fkMbInpv7y4HYZ3vC4LGE='
WHERE
key_id = 'b1a85068c2568d99a626fd5bdf58217e269d7050f67c4395290a2189b187a8b5'
AND (
token = '2LqFzHYDxhm6syZNCDqA04fkMbInpv7y4HYZ3vC4LGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)