UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqTKdZEWL+2dmrHGmZXeH1v7AyeoJmxYuoX6EhWZzn0='
WHERE
key_id = '0db4bd4c9804b240a84896b759ccb57289840abae30b7bf1a50a7954202c30f4'
AND (
token = 'pqTKdZEWL+2dmrHGmZXeH1v7AyeoJmxYuoX6EhWZzn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)