UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B7Ocf+nnQ7vYt1tuP9SfZdAFypWhGDDOa5bhCUonoIw=' 
WHERE 
  key_id = '8a943bc877296da0d058422ef9b3582aa88ec82ef9e989be2768fa29a1ec6025' 
  AND (
    token = 'B7Ocf+nnQ7vYt1tuP9SfZdAFypWhGDDOa5bhCUonoIw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00769