UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bV3GGeEg1CeWNzVu6YRpq/8LPpKEfE7hAbemKQqgPAk='
WHERE
key_id = 'e9e0ef11ab7da29a1d70c3fca5b25c18188a1ca2c7fd72e8d3763be1744e055e'
AND (
token = 'bV3GGeEg1CeWNzVu6YRpq/8LPpKEfE7hAbemKQqgPAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)