UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vAeF7WYzqCzltQGhDWNqVEbmD+J8vUOwMCWexAIGRCE='
WHERE
key_id = 'ae4a06e87c2fc8c885d94a444e290c639ff8bfb477facd477406a0e6f7a31929'
AND (
token = 'vAeF7WYzqCzltQGhDWNqVEbmD+J8vUOwMCWexAIGRCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)