SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '91ca7a0cf8e55f894f0907314dacc13602dcacd75310daf4ab22fc57b2175198' 
  AND token = 'tTNBPkyLXaMlGHUcvBKWoM6D50jb+KbNi+cIwyOoSo4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}