UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/RCVvkrzeKvA97tNmn8WVX6DByLIL4+AwLefP2Ru4Rk='
WHERE
key_id = 'e462ca2866f4c9674b060b04f21822394157931d1734c9dcda42da4ce4d5dbbd'
AND (
token = '/RCVvkrzeKvA97tNmn8WVX6DByLIL4+AwLefP2Ru4Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)