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