UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UgE8NxFJRXNIIofdMeM/jZYneb0QDVWlt+Aq0ZWdJf8='
WHERE
key_id = 'c54348c3d4fcce7361a049592991a2581adbd20237578fdc8aab4b5250735a20'
AND (
token = 'UgE8NxFJRXNIIofdMeM/jZYneb0QDVWlt+Aq0ZWdJf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)