UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XQMZcFRLLhh9R2X4e5hjY+K99AxeDB2aN7LmGQQZy8='
WHERE
key_id = 'ef1ef22b4243b93204380bfb57bd77ae563a246225a4338e27269d6268c3276f'
AND (
token = '/XQMZcFRLLhh9R2X4e5hjY+K99AxeDB2aN7LmGQQZy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)