SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '26de9e3025873756727e33140335dbe7a18700a6eef01a9c1a593fb29befb89f' 
  AND token = 'zRW4SpYpwj1xVMN8x1WbJ4tiaNQ+ge3WwT7VDWUJJKI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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