UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tiFSYS/K8cf7GI5BWBevQWLZwpOqYGNt3tNqey03alM='
WHERE
key_id = '45a39cd65d0a4562868c709bc70f012af113bf7d17a78ef3809b764da06b0a80'
AND (
token = 'tiFSYS/K8cf7GI5BWBevQWLZwpOqYGNt3tNqey03alM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)