UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/rbUAH8CKu9NLyCmPxi9E3uIW0WQ+en66hPJOHucls='
WHERE
key_id = 'ca467095e769b420ee8b0e49d5b718f981e73ad8f30ecba914df9b578128d40a'
AND (
token = 'X/rbUAH8CKu9NLyCmPxi9E3uIW0WQ+en66hPJOHucls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)