UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KlENVaFbRc0SwoGsyYORgxK8hBSxXuquHIy179Y8g48='
WHERE
key_id = '63d81d58cf3408c95d89e35cd70921042e2b286c20f99378f0dbe43c91a12a82'
AND (
token = 'KlENVaFbRc0SwoGsyYORgxK8hBSxXuquHIy179Y8g48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)