UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bsu6D2UXxOM4w55MDfi4yYcJjxHYoX18r9ex5Xd4q2c='
WHERE
key_id = '6ace7987ca69b72e01b450904ffe1993c101846c4f7d36622750b2c166d54010'
AND (
token = 'Bsu6D2UXxOM4w55MDfi4yYcJjxHYoX18r9ex5Xd4q2c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)