UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9coBw46WWgvWlF8sjBAH9OJB2d9P6u+zMvXin0hcv5c='
WHERE
key_id = '8996cf9bdd0a82ace48796be5ae988f47407ee136bb3d262930ced3cfb73e12e'
AND (
token = '9coBw46WWgvWlF8sjBAH9OJB2d9P6u+zMvXin0hcv5c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)