SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '259e635d814e0ab8a1ecf5fc854d161ff30ae980ddc1880cd80006d3470f068b' 
  AND token = 'KBUPWzRA9tKESMRKOOp6mfWuKcx/EzdG2DB7ARsF7Ew=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00052

JSON explain

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