SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8b0290a741c728cd99b87ad7fd70ba1054d382b5b8c74a45b2f668a8fa1663c0' 
  AND token = 'PdSuf1BOOSotBwYsuPf0K3mMg87Xgmbe0Iz5D3Qbq54=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00047

JSON explain

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