UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '++GQIy0DIENGTnFbKuCE2vtXkU3emPWFY3CcXJ87jDs='
WHERE
key_id = 'e1fc1cb3a21f06b70a8d85fe35106344612ce9c6537bc838051732588c04a5b0'
AND (
token = '++GQIy0DIENGTnFbKuCE2vtXkU3emPWFY3CcXJ87jDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)