UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6OoF3E0T0oHoWzKzISIv9H5eZYZyiYyIIsnoAfU6z5s=' 
WHERE 
  key_id = '4aaf3a17dc37951acf6c701b7d6f4c69765b3d429b5c7cc35927077abd76d644' 
  AND (
    token = '6OoF3E0T0oHoWzKzISIv9H5eZYZyiYyIIsnoAfU6z5s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028