UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kgo3sawea4bo2BFiTd6Bu/HFt31UaUJ/Z6HHgQ0FZaY=' 
WHERE 
  key_id = '30dfc275f879faa015c55576f36dbfdc64470ac1f0c0d1f4197415d2f54a4cda' 
  AND (
    token = 'kgo3sawea4bo2BFiTd6Bu/HFt31UaUJ/Z6HHgQ0FZaY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028