UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'haKThF9TJHyL8i9ZDhA9jwJ/SIRIb627gzt3j3W0tAc='
WHERE
key_id = '37f6188e929ade1a59fd5fd7324d239177c7abbdc72c4d1eebf198991a169ef9'
AND (
token = 'haKThF9TJHyL8i9ZDhA9jwJ/SIRIb627gzt3j3W0tAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)