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