UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBuw5qAFE0YI2nk7Jzx9Zg9AVklhO9ViATARjmiZbhM='
WHERE
key_id = '12f697f599f34eec0fa9ce4e40a020ca74c8ceb80fe6ef746edb0bae670c9529'
AND (
token = 'XBuw5qAFE0YI2nk7Jzx9Zg9AVklhO9ViATARjmiZbhM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)