UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3p8nHlZ1b4yd4NM5+SxPQTa3BZ3DCbd4AJS7nON93s='
WHERE
key_id = '4cb638e48883bf4ef784efe928b43a13dafc1f103a1837a3316d5577682a997f'
AND (
token = 'G3p8nHlZ1b4yd4NM5+SxPQTa3BZ3DCbd4AJS7nON93s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)