SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'cc41500db127d13036879d89af73f6aed1e771859e0dd9d48f39d229af257f4c' 
  AND token = 'lbskQ+tdOuyA4NV8PoFxeP2nTOu7O7Mv8qCXf2dPqCo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00049

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}