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