UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ktc/BsW989UExYkFJJ/KNJ2Bf6Qb9lJAR2h1tOzZP/M='
WHERE
key_id = '24377d33d7e846c3c9cc673788eb75c4efea754271e6eee0fe42b04a58878691'
AND (
token = 'ktc/BsW989UExYkFJJ/KNJ2Bf6Qb9lJAR2h1tOzZP/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)