UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+W2vn1KHlcS5/jy4r5/dE+FnKNVSfpnrrFGffsspiaU=' 
WHERE 
  key_id = 'e3a20c601ae3371b0f2c6bcadd2a88327de847abe5969ab11d3180cdbebc0679' 
  AND (
    token = '+W2vn1KHlcS5/jy4r5/dE+FnKNVSfpnrrFGffsspiaU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00751