UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3cCcSVclytDfwqvFNFDIn6Olfn+BAIU8asIc6IYWpVk=' 
WHERE 
  key_id = '07e064dd76257600299dbb6796f0b596dda56a50e657f8f5df23d54c27b8f8f5' 
  AND (
    token = '3cCcSVclytDfwqvFNFDIn6Olfn+BAIU8asIc6IYWpVk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00825