UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VTf8zU8ZbDE2vHgKNNo2edhKjtv8OnnP6GyttTn1NVo='
WHERE
key_id = '5bf2f9a69b283288ecc8c68502feffc7be3b2b07af0ca7e5826e2cdfbef40088'
AND (
token = 'VTf8zU8ZbDE2vHgKNNo2edhKjtv8OnnP6GyttTn1NVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)