UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tpy0mby/Ap6zzuAUE0aOKvDeWnVxx2i/c1HHhkQDGh0='
WHERE
key_id = '5ab0d8f084124c55cda71c17430ccc322d49598731c83e954b75d8500c11056b'
AND (
token = 'Tpy0mby/Ap6zzuAUE0aOKvDeWnVxx2i/c1HHhkQDGh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)