UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OV2v4x72RFrnHhi63HWL/g9Z3nAkHYvjT3pOu5LYUxA='
WHERE
key_id = '20583d5ea3800b93b25750c620c8206e12a61567bffd16340ea714a1671ff148'
AND (
token = 'OV2v4x72RFrnHhi63HWL/g9Z3nAkHYvjT3pOu5LYUxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)