UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A/rct8rd2J004YzeEiWSWAQDDj0lmxjOpoGgVCkfGwU='
WHERE
key_id = '0c4a03fcb475ac035ba86a004cec34d243a6acef1c9e5cb41471061944f8234f'
AND (
token = 'A/rct8rd2J004YzeEiWSWAQDDj0lmxjOpoGgVCkfGwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)