UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8oAGFklqSLfwY6VSX0E66oDDh9feakx1HH8inlK2bOw='
WHERE
key_id = '4dd7ec325168c2820013db0ae003f84f3ae70f77ffa9f612b1e822d1e61107ed'
AND (
token = '8oAGFklqSLfwY6VSX0E66oDDh9feakx1HH8inlK2bOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)