UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h0yIr9KIK+FGGuOmNYmERqtWD+zeprBYgV9EMRVw5hI='
WHERE
key_id = 'a604d69351091f252a17567f511596e5d6ad2280443267d91d0424181e07c8af'
AND (
token = 'h0yIr9KIK+FGGuOmNYmERqtWD+zeprBYgV9EMRVw5hI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)