UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KnYKr4AUUyOW/V0rTb7uesAoRJRrsTN8cCD7A/Igv8='
WHERE
key_id = '0901c3db5318d2c56f3f807a6df08bd2f73caaa1af18eef4ea86b89aed8f610a'
AND (
token = '0KnYKr4AUUyOW/V0rTb7uesAoRJRrsTN8cCD7A/Igv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)