UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b7A1n+kv0lKAWiQIZfGWgslcKUTM24vM1kXrJB+DPM0='
WHERE
key_id = 'ef9a935143b8a7f1e65021a6d4bcdc6347638a167845d0ad1734dad12b3cb65f'
AND (
token = 'b7A1n+kv0lKAWiQIZfGWgslcKUTM24vM1kXrJB+DPM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)