UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6P5412DsD4yobT4YLAtNKGrJqLaS2R83WGVP1+jW6RM=' 
WHERE 
  key_id = 'dbe18ce9b9a0c84e0c34c5cb5f15cd92afc1473fefa31e6fc51964d8e0521bfb' 
  AND (
    token = '6P5412DsD4yobT4YLAtNKGrJqLaS2R83WGVP1+jW6RM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00866