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