UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xE9xm7aMTj8FXISS0hKYi5PpFYwCXNgi5byc07CmQww='
WHERE
key_id = '7e60e783b0cec44377a10f6520da01d5b0018fefc286278a27aae073f99a4195'
AND (
token = 'xE9xm7aMTj8FXISS0hKYi5PpFYwCXNgi5byc07CmQww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)