UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'af3YC4N/fJTk4pvXlkH+PYP4THIHmzEc+gQUyR83ch8='
WHERE
key_id = 'b5c55588222e8fdb4b8ff954a315a65192a3169128bd43de53b69c993e77a8c3'
AND (
token = 'af3YC4N/fJTk4pvXlkH+PYP4THIHmzEc+gQUyR83ch8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)