UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmGfY4WIyN0712lrv3mjx+wulFA/kXR2LTUBB3LQsHg='
WHERE
key_id = 'fe86473ecf52fa4e94b737a90ede4d6deeb437c14be9d889bcba9d20b9b50e12'
AND (
token = 'xmGfY4WIyN0712lrv3mjx+wulFA/kXR2LTUBB3LQsHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)