UPDATE 
  tmall_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y4ZLpyJdqBfTeQXz+CDl85zorkuC6pTzkQbb9e+FOqM=' 
WHERE 
  key_id = 'e9fadb7864fda97a0dd0b77f5ffc4301eae2261ac994cea1c65fbbde6890cb9f' 
  AND (
    token = 'y4ZLpyJdqBfTeQXz+CDl85zorkuC6pTzkQbb9e+FOqM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00890