UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwnCiY8Uz1BXoPGFsotR6D+qToax8r8UA9hPBwgVzmU='
WHERE
key_id = '5ce068870eda9faab4d689ba3a4178e5a7921b985fe22a44edfce270db87d1a4'
AND (
token = 'hwnCiY8Uz1BXoPGFsotR6D+qToax8r8UA9hPBwgVzmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)